package com.xiguaji.tiktok.v1.ins.brand.repository;

import com.xiguaji.tiktok.v1.ins.brand.model.InsStBrandNation;
import org.springframework.data.jdbc.repository.query.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface InsStBrandNationRepository  extends CrudRepository<InsStBrandNation,Long> {

    @Query("select * from ins_st_brand_nation where bid = :bid order by nation_rank limit 0,:size")
    List<InsStBrandNation> findByBid(int bid,int size);
}
